Problems compiling DBD::Pg under IRIX 5.3

Dear all,

In order to get NULLs to be accepted as bind values for '?' in
prepare/execute statements, I have been trying to update my DBI/DBD::Pg set
up from its current status at DBI 1.02 and DBD::Pg 0.79.

Upgrade of DBI was trouble free and I know have DBI 1.13.

I have been unable to upgrade DBD::Pg (failed make outputs are at the end
of this mail)

for information:

perl, version 5.004_04 built for IP22-irix

Summary of my perl5 (5.0 patchlevel 4 subversion 4) configuration: Platform:   osname=irix, osvers=5,
archname=IP22-irix  uname='irix merlin 5.3 11091812 ip22 mips '   hint=recommended, useposix=true, d_sigaction=define
bincompat3=yuseperlio=undef d_sfio=undef Compiler:   cc='cc', optimize='-O', gccversion=   cppflags='-D_POSIX_SOURCE
-ansiposix-D_BSD_TYPES -DLANGUAGE_C'   ccflags ='-D_POSIX_SOURCE -ansiposix -D_BSD_TYPES -Olimit 3000
 
-DLANGUAGE_C'   stdchar='unsigned char', d_stdstdio=define, usevfork=false   voidflags=15, castflags=1,
d_casti32=define,d_castneg=undef   intsize=4, alignbytes=8, usemymalloc=n, prototype=define Linker and Libraries:
ld='ld',ldflags =' -L/usr/local/lib'   libpth=/usr/local/lib /usr/lib /lib   libs=-lmalloc -lsun -lm -lc -lcrypt -lbsd
-lPW  libc=/usr/lib/libc.so, so=so   useshrplib=false, libperl=libperl.a Dynamic Linking:   dlsrc=dl_dlopen.xs,
dlext=so,d_dlsymun=undef, ccdlflags=' '   cccdlflags='-KPIC', lddlflags='-shared -L/usr/local/lib'
 


Characteristics of this binary (from libperl): Built under irix Compiled at Mar 27 1998 17:20:27 @INC:
/usr/local/lib/perl5/IP22-irix/5.00404  /usr/local/lib/perl5   /usr/local/lib/perl5/site_perl/IP22-irix
/usr/local/lib/perl5/site_perl  /usr/local/lib/perl5/IP22-irix
 

First I tried with DBD::Pg 0.92 and got:

Configuring Pg
Remember to actually read the README file !
$POSTGRES_HOME not defined. Searching for PostgreSQL...
Found PostgreSQL in /usr/local/pgsql
irix
Checking if your kit is complete...
Looks good
Writing Makefile for DBD::Pg
mkdir ./blib
mkdir ./blib/lib
mkdir ./blib/lib/DBD
mkdir ./blib/arch
mkdir ./blib/arch/auto
mkdir ./blib/arch/auto/DBD
mkdir ./blib/arch/auto/DBD/Pg
mkdir ./blib/lib/auto
mkdir ./blib/lib/auto/DBD
mkdir ./blib/lib/auto/DBD/Pg
cp Pg.pm ./blib/lib/DBD/Pg.pm       /usr/local/bin/perl -I/usr/local/lib/perl5/IP22-irix/5.00404
-I/usr/local/lib/perl5 /usr/local/lib/perl5/ExtUtils/xsubpp  -typemap
/usr/local/lib/perl5/ExtUtils/typemap Pg.xs >Pg.tc && mv Pg.tc Pg.c       cc -c -I/usr/local/pgsql/include
-I/usr/local/include/pgsql
-I/usr/include/pgsql -I/usr/local/lib/perl5/site_perl/IP22-irix/auto/DBI
-I/usr/local/lib/perl5/IP22-irix/5.00404/DBI -I/auto/DBI -I/DBI
-D_POSIX_SOURCE -ansiposix -D_BSD_TYPES -Olimit 30
cfe: Warning 608: ./Pg.h: 24: Undefined the ANSI standard library defined
macro BUFSIZ (4.1.2.1(9))       cc -c -I/usr/local/pgsql/include -I/usr/local/include/pgsql
-I/usr/include/pgsql -I/usr/local/lib/perl5/site_perl/IP22-irix/auto/DBI
-I/usr/local/lib/perl5/IP22-irix/5.00404/DBI -I/auto/DBI -I/DBI
-D_POSIX_SOURCE -ansiposix -D_BSD_TYPES -Olimit 30
cfe: Warning 608: ./Pg.h: 24: Undefined the ANSI standard library defined
macro BUFSIZ (4.1.2.1(9))
cfe: Error: dbdimp.c, line 831: Incompatible pointer type assignment
(3.3.16.1, 3.5.4.1(21))                val = (((phs->sv)->sv_flags  & 0x00040000 )  ? (( len =
((XPV*)  (phs->sv)->sv_any )->xpv_cur ), ((XPV*)  (phs->sv)->sv_any
)->xpv_pv ) : Perl_sv_2pv (phs->sv, & len))
;-------------------------------------------------------------------------------
--------------------------------------------------------------------------------
-----------------^
cfe: Error: dbdimp.c, line 831: Type int *  of this argument  is
incompatible with type STRLEN *  of function prototype description
(3.3.16.1)                val = (((phs->sv)->sv_flags  & 0x00040000 )  ? (( len =
((XPV*)  (phs->sv)->sv_any )->xpv_cur ), ((XPV*)  (phs->sv)->sv_any
)->xpv_pv ) : Perl_sv_2pv (phs->sv, & len))
;-------------------------------------------------------------------------------
--------------------------------------------------------------------------------
-----------------^
*** Error code 1 (bu21) /sbin/make  -- NOT OK
Running make test Oops, make had returned bad status
Running make install Oops, make had returned bad status

So THEN I read the README (as one does)... and it mentioned that you needed
postgreSQL 6.4.2 onwards for DBD::Pg 0.92... it seemed like a long shot but
I thought perhaps that's what was causing the problem.

So I got hold of DBD::Pg 0.89 (the most up-to-date DBD::Pg compatible with
PG 6.4(.0)) and tried compiling that... again same error message (different
line):

cfe: Error: dbdimp.c, line 826: Incompatible pointer type assignment
(3.3.16.1, 3.5.4.1(21))                val = (((phs->sv)->sv_flags  & 0x00040000 )  ? (( len =
((XPV*)  (phs->sv)->sv_any )->xpv_cur ), ((XPV*)  (phs->sv)->sv_any
)->xpv_pv ) : Perl_sv_2pv (phs->sv, & len))
;-------------------------------------------------------------------------------
--------------------------------------------------------------------------------
-----------------^
cfe: Error: dbdimp.c, line 826: Type int *  of this argument  is
incompatible with type STRLEN *  of function prototype description
(3.3.16.1)                val = (((phs->sv)->sv_flags  & 0x00040000 )  ? (( len =
((XPV*)  (phs->sv)->sv_any )->xpv_cur ), ((XPV*)  (phs->sv)->sv_any
)->xpv_pv ) : Perl_sv_2pv (phs->sv, & len))
;-------------------------------------------------------------------------------
--------------------------------------------------------------------------------
-----------------^
*** Error code 1 (bu21)

Any help on getting the compile to work on my box would be greatly
appreciated as would be a cc to stuart@ludwig.ucl.ac.uk.

Best regards,

Stuart.

+--------------------------+--------------------------------------+
| Stuart C. G. Rison       | Ludwig Institute for Cancer Research |
+--------------------------+ 91 Riding House Street               |
| N.B. new phone code!!    | London, W1P 8BT                      |
| Tel. +44 (0)207 878 4041 | UNITED KINGDOM                       |
| Fax. +44 (0)207 878 4040 | stuart@ludwig.ucl.ac.uk              |
+--------------------------+--------------------------------------+